[dbo].[BAEImisGetCustomTableColumn]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisGetCustomTableColumn

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@TableName	varchar(30)	30
@FieldName	varchar(30)	30
@UserId	varchar(10)	10

SQL Script

create procedure [dbo].[BAEImisGetCustomTableColumn] @TableName as
varchar(30),
    @FieldName AS varchar(30),
    @UserId AS varchar(10)
AS
    DECLARE @SQLString     AS    NVARCHAR(1000)
    SET @SQLString = N'SELECT ' + @FieldName + ' FROM ' + @TableName + ' WHERE ID = ' + @UserId + ';'
    EXECUTE sp_executesql @SQLString

GO

Uses